Pivot Table is a tool which is perhaps the most technologically sophisticated component in Excel. It helps us summarize large amounts of data in rows and columns into a concise report. With only a few clicks of the mouse, and no complex formulas, we can summarize thousands of rows of data to show sums, averages, counts and other calculations.